Power BI- All in one

Created by : Rated :4.5 766 views

Last Updated: 2023-06-20 06:06:14 English Course Type: Self Learning

Power BI Development , Data Modelling, Power BI Admin, Custom Visual, DAX

Introduction to Power BI: Students will gain a basic understanding of what Power BI is and its role in business intelligence. They will learn about the different components of Power BI, including Power BI Desktop, Power BI Service, and Power BI Mobile. Data Sources and Data Transformation: Students will learn how to connect to various data sources, such as databases, Excel files, SharePoint, and online services. They will understand how to import and transform data using Power Query Editor to clean and shape the data for analysis. Data Modeling: Students will learn about data modeling concepts in Power BI. They will understand how to create relationships between different tables, define measures and calculated columns using DAX (Data Analysis Expressions), and create hierarchies for organizing data. Data Visualization: Students will gain skills in creating visually appealing and interactive reports and dashboards in Power BI. They will learn how to use different types of visualizations (such as charts, tables, maps, and slicers) to present data effectively. They will also explore formatting options and best practices for designing engaging visualizations. Power Query: Students will learn advanced techniques in Power Query for data transformation and manipulation. They will understand how to use functions, conditional statements, and other data shaping techniques to clean and prepare data for analysis. DAX (Data Analysis Expressions): Students will gain proficiency in using DAX formulas to create calculations, measures, and calculated columns in Power BI. They will learn how to write DAX expressions for aggregating, filtering, and manipulating data to derive meaningful insights. Interactive Reports and Dashboards: Students will learn how to create interactive reports and dashboards in Power BI. They will understand how to add interactivity through slicers, filters, and drill-through actions to enable users to explore data and gain insights. Data Refresh and Sharing: Students will learn how to refresh data in Power BI and schedule automatic data refreshes. They will understand how to publish and share reports and dashboards with others, both within the organization and externally. Power BI Service: Students will gain an understanding of the Power BI Service, which is the cloud-based platform for sharing and collaborating on Power BI content. They will learn how to publish reports, create workspaces, manage access and permissions, and utilize collaboration features. Advanced Analytics and Custom Visualizations: Depending on the course, students may also learn about advanced analytics features in Power BI, such as forecasting, clustering, and sentiment analysis. They may also explore custom visualizations, where they can import and use third-party visualizations to extend the capabilities of Power BI.Power BI Service Overview: Students will gain an understanding of Power BI Service, which is the cloud-based platform for sharing, collaborating, and publishing Power BI reports and dashboards. They will learn how to navigate the Power BI Service interface, manage workspaces, and utilize collaboration features. Sharing and Collaboration: Students will learn how to share Power BI reports and dashboards with colleagues, teams, and stakeholders. They will understand different sharing options, set access permissions, and manage content collaboration within Power BI Service. Data Refresh and Scheduling: Students will learn how to schedule and manage data refresh in Power BI Service. They will understand how to configure automatic data refresh for reports and datasets, ensuring that the data is up to date and accurate. Power BI Mobile: Students will explore Power BI Mobile, the mobile app for accessing and interacting with Power BI reports and dashboards on smartphones and tablets. They will learn how to navigate the app, view reports offline, and utilize mobile-specific features for enhanced user experience. DAX Formulas and Functions: Students will dive deeper into DAX formulas, which are used for calculations and data modeling in Power BI. They will learn advanced DAX functions and techniques for creating complex calculations, time intelligence, filtering, and conditional logic. Calculated Columns and Measures: Students will understand the difference between calculated columns and measures in Power BI and when to use each. They will learn how to create and use calculated columns and measures effectively for data analysis and visualization. Advanced Data Modeling: Students will learn advanced data modeling techniques using DAX in Power BI. They will explore concepts such as hierarchies, calculated tables, and many-to-many relationships. They will understand how to optimize data models for performance and efficiency. Advanced Visualization Techniques: Students will gain skills in creating advanced visualizations using DAX expressions. They will learn how to use DAX to customize and enhance visualizations, create dynamic visuals, and implement advanced charting techniques. Advanced Analytics with DAX: Students will explore advanced analytics capabilities in Power BI using DAX. They will learn how to perform statistical analysis, implement advanced calculations, and create complex data models to support advanced analytics scenarios. Performance Optimization: Students will understand techniques for optimizing the performance of Power BI reports and dashboards. They will learn how to improve query performance, optimize data models, and manage large datasets efficiently.

Power BI Desktop tool and SQL Knowledge

All level

Section 1 : Unpublished Section 41 Lectures 05:56:02
Lecture 1 :
Power BI Installation-1 Preview
Lecture 2 :
Power BI Installation-2
Lecture 3 :
Report Creation
Lecture 4 :
Visual Properties-Sorting,spotlight,export,focus mode
Lecture 5 :
Filter Types 1- Visual, Page, Report, DrillThrough
Lecture 6 :
Filter Types 2 - Basic, Advanced, TopN
Lecture 7 :
Edit Interaction, Sync Slicer
Lecture 8 :
BookMark-Switch Visuals
Lecture 9 :
BookMark-Toggling
Lecture 10 :
Tooltip
Lecture 11 :
Drill Down
Lecture 12 :
Conditional Formatting
Lecture 13 :
Ribbon 1
Lecture 14 :
Ribbon 2
Lecture 15 :
TransformData- Add Column Tab
Lecture 16 :
TransformData-Home Tab
Lecture 17 :
TransformData-Home Tab 2
Lecture 18 :
TransformData-Home Tab 3
Lecture 19 :
TransformData-Transform Tab
Lecture 20 :
PBI Services-Email Creation
Lecture 21 :
PBI Services-Publish Report, Workspace, Dashboard
Lecture 22 :
PBI Services-Create Report,dataset,Download,Export,QR Code,Search,View
Lecture 23 :
PBI Services-Metrics,Quick Insight,Subscription,Sharing,RLS
Lecture 24 :
PBI Services-Quick Insight
Lecture 25 :
PBI Services-Delete,Uses of Shared with me, AppCreation
Lecture 26 :
PBI Services-ScheduleRefresh,Gateway Installation
Lecture 27 :
DAX-Date and Time Functions
Lecture 28 :
DAX-Text Functions
Lecture 29 :
DAX-Logical Functions
Lecture 30 :
DAX-Information Functions
Lecture 31 :
DAX-Math _ Statistical Functions
Lecture 32 :
DAX-Time Intelligence Functions
Lecture 33 :
DAX-Table Functions
Lecture 34 :
Relationship Overview
Lecture 35 :
Relationship 1
Lecture 36 :
Relationship 2
Lecture 37 :
Relationship 3
Lecture 38 :
SQL Connection
Lecture 39 :
Web Connection
Lecture 40 :
Visual Align
Lecture 41 :
Custom Visual

How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.
Are these video based online self-learning courses?
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
Can i play & pause the course as per my convenience?
Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
How do i contact the instructor for any doubts or questions?
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
Do i need a pc to access the course or can i do it on mobile & tablet as well?
Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.
Is there any free trial?
Currently, we do not offer any free trial.
Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?

Sachin Agrawal,

3573 Course Views

4 Courses

I am a Microsoft Certified Power BI, SQL, MSBI freelance Trainer with International training exposure. I had Provided 10+ corporate level training. Also I have trained 2000+ participants till 2023. Training provided to all age groups (22 to 60+ Yrs.).Having good exposure into BI Tools like SQL, SSIS, SSRS, SSAS, Power BI. I have received 98% positive feedback on my practical training. I have 16 Years of experience in IT industry.