Power BI 데이터 분석 + Microsoft 365 certified

Master Power BI: Data Visualization & Business Intelligence

Unlock the power of data with this comprehensive Power BI course! Learn to transform raw data into actionable insights using Microsoft's leading business intelligence solution. This course is perfect for professionals looking to enhance their skills and make a significant impact in their organization or during job interviews.

Get Started with Power BI Desktop (Free!)

This course begins with a step-by-step guide to installing Power BI Desktop, a free and intuitive application. You'll quickly learn how to connect to and model data from various sources. This is a valuable skill that can truly set you apart, whether in a corporate setting or during a job interview.

Resources:

• [View all screenshots in section 1](link to screenshots)
• Download 540 navigable PowerPoint Slides: Explore the administration system and key Microsoft 365 applications with detailed screenshots and comments (Korean & English versions available).

Microsoft Certification & Career Advancement

Looking to validate your skills? This course prepares you for the Microsoft Certified: Fundamentals certification. It's a fantastic addition to your resume and demonstrates your ability to contribute to your company's productivity.

• Practice with 1875 Objective Questions: Comprehensive practice questions with detailed explanations of correct answers. Find links to the official Microsoft page for exam details and costs.

Course Objectives: Data Visualization & Modeling

This course equips you with the essential tools to begin using Power BI. You'll learn how to:

• Connect to existing data sources (Excel, Access, SharePoint, and more).
• Model data for insightful visualizations.
• Create interactive reports and customized dashboards.
• Monitor key business metrics in real-time.
• Leverage data security features like row-level security.
• Integrate Power BI with other Microsoft applications like Azure and Teams for enhanced collaboration.

Bonus: A dedicated section covers setting up Microsoft 365 accounts for users and groups – a foundational skill for using Power BI and other Microsoft applications.

Downloadable Resources:

• 85 PowerPoint Slides: Supporting video lessons with clickable navigation.
• Microsoft Access Software Licensing for Power BI Synchronization: Learn how to synchronize with Microsoft Access. (Screenshots available).
• YouTube Video Tutorials: Access a wealth of video tutorials with subtitles in 18 languages. (Details at the bottom of the presentation).
• 222-Page Microsoft 365 Global Account Manager E-book (PDF): Explore the index in the section screenshots.

DAX Formulas & Database Access

Dive deeper into data analysis with DAX (Data Analysis Expressions) formulas. This section provides 7230 DAX formulas, explained with practical examples using the ADVENTURE WORKS model. Learn how to dynamically generate data for use in graphical objects.

Key DAX Concepts Covered:

• Function Categories: A detailed breakdown of DAX functions grouped by utility (Aggregation, Logic, Date & Time, Table Manipulation, Business Intelligence, Parent/Child, Filter, Relationship, Lookup, Financial, Residual).
• In-depth Explanations: Understand the purpose and application of each function.
• Business Scenarios: 10 real-world examples of how to use each function.
• Formula Examples: 10 examples of formulas used independently and as arguments within other functions.

Microsoft Access Licensing for Power BI Synchronization

This section focuses on using Microsoft Access with Power BI. It includes:

• Process Management: Manage courses, students, teachers, and registrations for educational institutions and sports associations. Customizable masks and reports.
• Complete Management of Company and ISO 9001 Quality Systems: Manage personal data, invoices, performance evaluations, and more. Customizable masks and reports.

Key Management Areas:

• Management Control: Fixed costs, variable costs, break-even analysis.
• Supplier Management: Personal data, invoices, performance evaluations.
• Customer Management: Customer files, invoices, satisfaction surveys, complaint management.
• Invoice Management: Inventory, VAT balance, cash flow simulations.
• Warehouse Management: Incoming/outgoing shipments, delivery receipts, inventory valuation.
• Human Resources Management: Employee data, salaries, attendance records.
• Order & Quotation Management: Manage orders and quotations from customers and suppliers.
• ISO 9001 Quality System Management: Audits, improvement projects, preventive actions, quality planning, non-conformities, corrective actions, management reviews, performance indicators, SWOT analysis, calibration sheets.