This plan includes
- Limitedfree coursesaccess
- Play & PauseCourse Videos
- VideoRecorded Lectures
- Learn onMobile/PC/Tablet
- Quizzes andReal Projects
- Lifetime CourseCertificate
- Email & ChatSupport
What you'll learn?
- How to install Power BI Desktop
- How to connect Power BI to different sources of data
- How to clean and prepare data in Power BI
- How to create and manage relationships between data sets in Power BI
- How to analyse and visualize data in Power BI
- How to create advanced charts in Power BI (Map, Treemap, Gauge, Waterfall)
- How to create interactive dashboards in Power BI
- How to turn raw data into business insights by Power BI
- How to use Power Add-ins in MS Excel
Course Overview
Join over 2,000 students and learn all essential tools and techniques for business data analysis in Power BI. Become an expert of Power BI in a short period. Learn how to turn raw data into business insights and make data-driven recommendations by Power BI.
WHY WOULD YOU CHOOSE TO LEARN POWER BI?
Power BI is quickly gaining popularity among professionals in data analysis as a cloud-based service that helps them easily visualize and share insights from their organizations' data. Advanced Power BI skills can get you a promotion and make you a rock star at your company.
WHY TAKE THIS SPECIFIC POWER BI COURSE?
There are many Power BI courses out there teaching you the important functions and features you need to master.
But, can you apply what you learnt to your own files? Do you get enough practice to remember all the new information?
This course is concentrated on the most important tools for performing data analysis on the job. In this course you'll play the role of data analyst at a delivery company and you'll be working with real-life data sets. You don't need to spend weeks and months to learn Power BI. As you go through the course, you'll be able to apply what you learnt immediately to your job.
Author of this course has over 10 years of working experience in large financial organizations and over 5 years of experience of online and in-person trainings. He has dozens of courses on Excel, SQL, Power BI, Access, and more than 10,000 students in total. Surely he knows what you need.
If you want to take your skills of data analytics to the next level, this course is definitely for you.
HEAR ARE SOME STUDENT REVIEWS:
★★★★★ Alex Kapogiannis
Very informative and nicely paced, suitable for every level of user! Course gives you all around knowledge of the subject, very good for building up confidence on handling and mastering Power BI. Keep up the good work!
★★★★★ Francis Mwangangi Kivuti
The explanation are clear and the examples match real life scenarios
★★★★★ Vardan Danielyan
This is an excellent course for beginners as well as intermediate and advanced users. It breaks down some important concepts in a manner that is clear and understandable for problem solving. The course is very detailed and well explained. It is invaluable both for learning and for reference. With a lesson approach it is easy to learn, practice and gain some mastery.
WHAT ARE SOME POWER BI TOOLS AND FUNCTIONS YOU WILL LEARN IN THIS COURSE?
You'll learn:
· How to connect different types of data to Power BI.
· How to organize, clean and manage data in Power BI.
· How to create relationships between different data sets in Power BI.
· How to best navigate large data and large spreadsheets.
· Power BI charts that go beyond Column and Bar charts. You'll learn how to create Combo charts, Gauge, Map, Waterfall, Treemap, Histogram charts and more.
· How to create interactive dashboards in Power BI by using Slicer.
· How to set up automatically update of your dashboards based on external data updates.
· How to publish your project to Power BI Service.
· Make homework and solve quizzes along the way to test your new Power BI skills.
Join today and get immediate, lifetime access to the following:
· Downloadable Power BI project files
· In demand course content
· Homework exercises & quizzes
· Free support from the instructor
· Certificate of Completion
See you in there!
Sincerely,
Vardges Zardaryan
P.S. Looking to master the full Microsoft Excel and Power BI stack? Search for "Vardges Zardaryan" and complete the courses below to become a Data Analysis Rock Star:
1. Data Analysis and Statistics with Excel
2. Power BI Masterclass from Scratch
3. Analytics Techniques: Excel + MySQL + Power BI
Pre-requisites
- Microsoft Power BI Desktop (free download)
- Experience with Excel is a plus, but not required
- Passion for online learning
Target Audience
- Anyone looking for a hands-on course on Microsoft Power BI Desktop
- Data analysts and Excel users hoping to develop advanced data modeling, dashboard design, and business intelligence skills
- Students who want a comprehensive, engaging, and highly interactive approach to training
- Anyone looking to pursue a career in data analysis or business intelligence
Curriculum 36 Lectures 02:14:25
Section 1 : Course Overview
- Lecture 2 :
- Power BI vs MS Excel
- Lecture 3 :
- Installation of Power BI Desktop
- Lecture 4 :
- Download the Working File
Section 2 : Importing Data
- Lecture 1 :
- Import Excel File
- Lecture 2 :
- Import CSV File
- Lecture 3 :
- Import Data from SQL Database
Section 3 : Cleaning and Preparing Tools
- Lecture 1 :
- Basic Transformations
- Lecture 2 :
- Working with Dates
- Lecture 3 :
- Splitting Columns
- Lecture 4 :
- Conditional Columns
- Lecture 5 :
- Calculated Columns
- Lecture 6 :
- Calculation of Statistics
- Lecture 7 :
- Apply Transformations
- Lecture 8 :
- Creation of Relationships
Section 4 : Charts and Graphs
- Lecture 1 :
- Bar Chart
- Lecture 2 :
- Column Chart
- Lecture 3 :
- Pie Chart
- Lecture 4 :
- Column with Line
- Lecture 5 :
- Treemap
- Lecture 6 :
- Map Chart
- Lecture 7 :
- Waterfall Chart
- Lecture 8 :
- Gauge Chart
Section 5 : Visualization Techniques
- Lecture 1 :
- Cards and KPI
- Lecture 2 :
- Table and Matrix
- Lecture 3 :
- Slicer
- Lecture 4 :
- Image, Textbox, Shape
- Lecture 5 :
- Visual Relationship
Section 6 : Extra Functionalities
- Lecture 1 :
- Duplicate Page
- Lecture 2 :
- Export Data
- Lecture 3 :
- Enter Data Manually
- Lecture 4 :
- Update Project Data
- Lecture 5 :
- Wrapping-Up
Section 7 : Bonus Lectures
- Lecture 1 :
- Publishing Project to Power BI Service
- Lecture 2 :
- Power Add-ins in Excel vs Power BI
Section 8 : Test Yourself
- Lecture 1 :
- Final Quiz
Our learners work at
Frequently Asked Questions
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?
Instructor
322407 Course Views
3 Courses