Elite

Power BI

About Course

  • This course is aimed at learners who are looking to get started with the Power BI Desktop software. Power BI Desktop is a free Business Intelligence application from Microsoft that lets you load, transform, and visualize data. You can create interactive reports and dashboards quite easily, and quickly.
  •  

Description

  • Power BI is a business analytics solution that lets you visualize your data and share insights across your organization, or embed them in your app or website. The solution comprises several products and services, value and versatility comes from leveraging the individual elements, and taking advantage of how they work together.
  • Power BI is a radically new tool in the hands of business enterprises who are overwhelmed with the amount of data at hand and until now did not have a cost-effective tool to extract insights from it. Upon the completion of this Power BI you can start using this BI tool, which is a set of tools and applications that let you extract data from multiple unrelated sources and convert it into a neatly managed and coherent set of information, visually appealing insights, interactive data, charts, graphs, and reports, etc.

What will I learn

  • How to Connect Microsoft Power BI to data sources
  • How to Create Barcharts
  • How to Create Treemaps
  • How to Create Donut Charts
  • How to Create Waterfall Diagrams
  • How to Create Piecharts
  • How to use Power BI Desktop to import and model data and create reports.
  • How to use the Power BI service for the creation of dashboards, collaboration and sharing of content.

Topics

    1. Introducing the Course Project
    2. Course Structure & Outline
    1. Meet Power BI
    2. Downloading Power BI & Adjusting Settings
    3. The Power BI Interface & Workflow
    4. Helpful Resources
    5. QUIZ: Introducing Power BI Desktop
    1. Introduction
    2. Types of Data Connectors
    3. The Query Editor
    4. Basic Table Transformations
    5. Text-Specific Tools
    6. Number-Specific Tools
    7. Date-Specific Tools
    8. PRO TIP: Creating a Rolling Calendar
    9. Index & Conditional Columns
    10. Grouping & Aggregating Data
    11. Pivoting & Unpivoting
    12. Merging Queries
    13. Appending Queries
    14. PRO TIP: Appending Files from a Folder
    15. Data Source Settings
    16. Query Refresh Settings
    17. Additional Data Types & Categories
    18. Defining Hierarchies
    19. PRO TIP: Importing Models from Excel
    20. Data Connection Best Practices
    21. QUIZ: Connecting & Shaping Data
    22. HOMEWORK: Connecting & Shaping Data
    1. Introduction
    2. What is a “Data Model”?
    3. Database Normalization
    4. Data Tables vs. Lookup Tables
    5. Relationships vs. Merged Tables
    6. Creating Table Relationships
    7. “Snowflake” Schemas
    8. Managing & Editing Relationships
    9. Active vs. Inactive Relationships
    10. Relationship Cardinality
    11. Connecting Multiple Data Tables
    12. Understanding Filter Flow
    13. Two-Way Filters (Use with Caution!)
    14. Hiding Fields from Report View
    15. Data Model Best Practices
    16. QUIZ: Creating a Data Model
    1. Introduction
    2. Meet DAX
    3. Intro to Calculated Columns
    4. Intro to Measures
    5. RECAP: Calculated Columns vs. Measures
    6. Adding Columns & Measures
    7. Implicit vs. Explicit Measures
    8. Filter Context Examples
    9. Step-by-Step Measure Calculation
    10. DAX Syntax & Operators
    11. Common DAX Function Categories
    12. Basic Date & Time Functions
    13. Logical Functions
    14. Text Functions
    15. Joining Data with RELATED
    16. Basic Math & Stats Functions
    17. COUNT Functions
    18. The CALCULATE Function
    19. CALCULATE & ALL
    20. CALCULATE & FILTER
    21. Iterator (“X”) Functions
    22. DAX Time Intelligence Formulas
    23. DAX Best Practices
    24. QUIZ: Adding Calculated Fields
    25. HOMEWORK SOLUTION: Adding Calculated Fields
    1. Introduction
    2. The “Report” View
    3. Adding Simple Objects
    4. Inserting Basic Charts & Visuals
    5. Formatting Options
    6. Report Filtering Options
    7. DEMO: Matrix Visuals
    8. DEMO: Date Slicers
    9. DEMO: Cards & KPIs
    10. DEMO: Text Cards
    11. DEMO: Map Visuals
    12. DEMO: Treemaps
    13. DEMO: Line & Area Charts
    14. DEMO: Trend Lines & Forecasts
    15. DEMO: Gauge Charts
    16. Editing Report Interactions
    17. Adding Drillthrough Filters
    18. Adding Report Bookmarks
    19. “What-If” Parameters
    20. Managing & Viewing Roles
    21. PREVIEW: Custom Visuals (Log-in Required)
    22. PREVIEW: Designing for Phone vs. Desktop
    23. PREVIEW: Publishing to Power BI Service
    24. Data Visualization Best Practices
    25. QUIZ: Visualizing Data with Reports
    26. HOMEWORK SOLUTION: Visualizing Data with Reports
    1. Resources & Next Steps
    2. More from Maven Analytics
    1. Introduction
    2. PART 1: Connecting & Shaping the Data
    3. PART 2: Creating the Data Model
    4. PART 3: Adding DAX Measures
    5. PART 4: Building the Report

Why? - Description

  • Microsoft Power BI is right for your organization?
  • Real-time information. Dashboards update in real time, as data is pushed or streamed in, which gives viewers the ability to solve problems and identify opportunities quickly.
  • Cortana integration. Power BI works with Microsoft’s digital assistant, Cortana. Users can verbally ask questions in natural language to access charts and graphs. This can be especially helpful for users with mobile devices.
  • Artificial Intelligence. Power BI users can access image recognition and text analytics, create machine learning models, and integrate with Azure Machine Learning.
  • Ability to customize Power BI app navigation. An “app navigation experiences” feature gives report developers the power to customize navigation to help viewers find content quickly and understand the relationships between different reports and dashboards.

Target Audience

  • who want to improve their programming skills by applying industry best practices in their daily work.
  • Individuals looking to learn python
  • Project Managers, Software architects and Development Team Leaders, who want to implement or improve a software development process within a project, and who want to define a project or company-wide set of recommended tools and best practices.
  • Project Managers, Software architects and Development Team Leaders, who want to implement or improve a software development process within a project, and who want to define a project or company-wide set of recommended tools and best practices.
Enroll Now