What you'll learn
How to create stunning, interactive dashboards with Power BI
How to share your analysis and dashboards using Power Bi Online
To import CSV and Excel files into Power BI Desktop
All about DAX including using the COUTROWS, CALCULATE, and SAMEPERIODLASTYEAR functions
All about using the card visual to create summary information
How to create amazing visuals, such as clustered column charts, maps, and trend graphs
How to use Slicers to filter your reports
How to edit the interactions between your visualizations and filter at visualization, page, and report level
Requirements
A good knowledge of MS Excel is advised but not necessary
Power BI Desktop installed on your machine is required to take the practice exercises
Description
**This course includes practice exercise files and LIFETIME access**Learn Microsoft Power BI with this brilliant beginner course from Microsoft experts Simon Sez IT.Power BI is an incredibly powerful, self-service Business Intelligence (BI) solution from Microsoft. It is the perfect Business Intelligence tool for people with limited technical experience.In this Power BI course, we start by looking at Power Query, and how to use this tool to organize and clean our data. We then show you how to build a Data Model and relate separate tables. After that, we teach you all about the data analysis language DAX in Power BI. Finally, we look at how to present this data using the charts and graphs available.In this course you will learn:What is Power BI and why you should be using it.To import CSV and Excel files into Power BI Desktop.How to use Merge Queries to fetch data from other queries.How to create relationships between the different tables of the data model.All about DAX including using the COUTROWS, CALCULATE, and SAMEPERIODLASTYEAR functions.All about using the card visual to create summary information.How to use other visuals such as clustered column charts, maps, and trend graphs.How to use Slicers to filter your reports.How to use themes to format your reports quickly and consistently.How to edit the interactions between your visualizations and filter at visualization, page, and report level.***Exercise and demo files included***This course includes:4+ hours of video tutorials45 individual video lecturesExercise files to practice what you learnedCertificate of completionHere's what our students are saying."Brilliant course. I'm quite new to the world of POWER and this course has shown me what it can do in a way that a newbie can understand. Recommended. I will be looking for other courses by them."- Andrew"Very detailed course, really enjoyed the Power BI course. Simon has done a really good job explaining each process step. Looking forward to completing additional Power BI courses for advanced techniques."- Martin"I would highly recommend. The course was informative and easy to follow."- Thomas"Great match! Learning so much and I love the quick step by step videos."- Vikki
Overview
Section 1: Introduction
Lecture 1 Welcome and Overview
Lecture 2 WATCH ME: Essential Information for a Successful Training Experience
Lecture 3 DOWNLOAD ME: Course Demo Files (Section 2-4)
Lecture 4 DOWNLOAD ME: Course Demo Files (Section 5-
Lecture 5 DOWNLOAD ME: Course Exercise File
Lecture 6 DOWNLOAD ME: Course Transcript
Lecture 7 What is Power BI?
Lecture 8 Install Power BI Desktop
Lecture 9 A Tour of BI Desktop
Lecture 10 Explore Commonly Used Power BI Options
Section 2: Getting and Transforming Data
Lecture 11 Import Files from a Folder into Power BI Desktop
Lecture 12 Get Data from Excel and Text Files
Lecture 13 Changing Query Source
Lecture 14 Reference Queries to Create Additional Lookup Tables
Lecture 15 Merge Queries in Power Query
Lecture 16 Prevent Queries from Loading into Power BI Desktop
Lecture 17 Practise Exercise
Section 3: Data Modelling
Lecture 18 Create Relationships Between Tables
Lecture 19 Create a Dynamic List of Dates
Lecture 20 Create Additional Date Columns for Analysis
Lecture 21 Sort the Month and Weekday Names Correctly
Lecture 22 Mark the Table as a Date Table
Lecture 23 Hide Unnecessary Fields from Report View
Lecture 24 Practise Exercise
Section 4: Introduction to DAX Measures
Lecture 25 Calculate the Total Revenue
Lecture 26 Count the Total Rows of a Table
Lecture 27 Use the CALCULATE Function
Lecture 28 Calculate the Total Revenue Last Year
Lecture 29 Difference Compared to Last Year
Lecture 30 Practise Exercise
Section 5: Adding Visualizations to your Report
Lecture 31 Show Summary Information with Cards
Lecture 32 Columns Charts to Compare Values
Lecture 33 Map Visual to Plot Geographic Data
Lecture 34 Slicers to Filter your Reports
Lecture 35 KPI Card to Measure Performance Against a Goal
Lecture 36 Line Graphs to Visualise Trend
Lecture 37 Show Detail with the Matrix
Lecture 38 Top N Lists with the Table Visualisation
Lecture 39 Practise Exercise
Section 6: Report Design
Lecture 40 Adding Text Boxes and Shapes
Lecture 41 Use Themes
Lecture 42 Conditional Formatting
Lecture 43 Practise Exercise
Section 7: Editing Interactions and Filters
Lecture 44 Edit the Interactions between your Visualisations
Lecture 45 The Filter Pane to Filter at Any Level
Lecture 46 Drill Through to More Detail
Lecture 47 Practise Exercise
Section 8: Power BI Service
Lecture 48 Publish Your Report to the Power BI Service
Lecture 49 Different Ways to Share your Power BI Report
Lecture 50 Practise Exercise
Section 9: Closing
Lecture 51 Wrap Up
Advanced Excel users


rapidgator.net:

Código:

https://rapidgator.net/file/fd0d17f7c84a82e78f53242cb8507346/qlyod.Microsoft.Power.Bi.For.Beginners.Get.Started.With.Power.Bi.part1.rar.html
https://rapidgator.net/file/93e031cf9f983f707d0f809ec6702be2/qlyod.Microsoft.Power.Bi.For.Beginners.Get.Started.With.Power.Bi.part2.rar.html
https://rapidgator.net/file/5783aee0aab6adbca162eeca87577541/qlyod.Microsoft.Power.Bi.For.Beginners.Get.Started.With.Power.Bi.part3.rar.html

uploadgig.com:

Código:

https://uploadgig.com/file/download/04c318AF93c8593f/qlyod.Microsoft.Power.Bi.For.Beginners.Get.Started.With.Power.Bi.part1.rar
https://uploadgig.com/file/download/21c1A5689de81B47/qlyod.Microsoft.Power.Bi.For.Beginners.Get.Started.With.Power.Bi.part2.rar
https://uploadgig.com/file/download/163f38DF467c0f98/qlyod.Microsoft.Power.Bi.For.Beginners.Get.Started.With.Power.Bi.part3.rar

1dl.net:

Código:

https://1dl.net/r8ijtj15ilre/qlyod.Microsoft.Power.Bi.For.Beginners.Get.Started.With.Power.Bi.part1.rar.html
https://1dl.net/inhr63p2fgkp/qlyod.Microsoft.Power.Bi.For.Beginners.Get.Started.With.Power.Bi.part2.rar.html
https://1dl.net/2o1wp0d1a1co/qlyod.Microsoft.Power.Bi.For.Beginners.Get.Started.With.Power.Bi.part3.rar.html

nitroflare.com:

Código:

https://nitroflare.com/view/A1D28699E2B9D02/qlyod.Microsoft.Power.Bi.For.Beginners.Get.Started.With.Power.Bi.part1.rar
https://nitroflare.com/view/5A2A0A199368C34/qlyod.Microsoft.Power.Bi.For.Beginners.Get.Started.With.Power.Bi.part2.rar
https://nitroflare.com/view/7A738DF12A5191E/qlyod.Microsoft.Power.Bi.For.Beginners.Get.Started.With.Power.Bi.part3.rar