Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Business Business Analytics & Intelligence Business Analytics

Advance Sales Analytics for Decision Making with Power BI

Learn to discover meaningful insights from your data to boost sales especially designed for Non-IT Professionals
Rating: 4.2 out of 54.2 (230 ratings)
18,973 students
Created by Muhammad Kashif
Last updated 4/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Build professional quality ADVANCE SALES ANALYTICS reports from ground up
  • Blend and transform raw data into beautiful INTERACTIVE DASHBOARDS
  • Showcase your skills with full scale course projects with SIX SPECIALIZED sales analytics dashboard (step by step solutions)
  • ARTIFICIAL INTELLIGENCE of Power BI to extract insights
  • Work comfortably with Microsoft Power BI
  • Work with large amount of data WITHOUT difficulty
  • Learn to use FILTERS and SLICERS to ask the MEANINGFUL questions of your data
  • Learn to create POWERFUL tables and matrix's of reporting data
  • Learn to use CUSTOM Visualizations and Themes in Power BI
  • SAVE huge amount of time which was previous consumed to extract same results
  • DYNAMICALLY interact with your data
  • Find insights PREVIOUSLY IT professionals could discover
  • Master DAX formulas and concepts
  • DISCOVER important Power BI tips & techniques
  • Use of MEASURE BRANCHING
  • WHAT IF PARAMETER in Reports
  • GROUPING TECHNIQUES for more insightful reports
  • VIRTUAL relationship among tables

Requirements

  • Microsoft Power BI Desktop (free download)
  • Absolutely no prior experience in Power BI is required as we will start from scratch

Description

According to Mckinsey in their report on “Unlocking the Power of Data in Sales,” they have identified that over 53 % of the High Performing sales organizations are those who are effectively using their data analytical skills to boost sales. They have used techniques like cross-selling opportunities or new customer analytics during the process. And we will do exactly the same in this course.

The digital universe is expanding with the passage of every day and organizations or persons who have the ability to utilize data analytics skills will have a competitive advantage by responding to the business challenges more quickly, more rigorously, and more successfully than their competitors.

This course is a perfect one-stop-shop for those of you who like to peruse a career in data analytics, business analytics, or Financial analysis. You will acquire practical skills that will turn you into a highly skillful talent which will be invaluable for your future career. Get excited as you have come to the right place at the right time.

This is one of the few courses on this topic that will equip you for detailed insights into sales analytics where we will start from very basics like how to install Power BI getting data into Power BI, develop a relationship among tables. We look forward to having you on our course as we learn and explore the incredible power of Microsoft Power BI for:

  • Specialized Sales Analytics Insights

  • Product Insights, Customers Insights and Salespersons Insights

  • Prepare Sales Budgets

  • Artificial Intelligence of Power BI to extract insights

  • Specialized scenarios related to sales and their respective solutions in Power BI.

  • Discover real-life situations like cross-selling opportunities and new customer analytics

  • Basic to Advanced DAX calculations

  • Measure Branching

  • What if Parameter in Reports

  • Grouping Techniques

  • The virtual relationship among tables

  • Use of variables in DAX

  • Harness the real analytical power behind Power BI

  • Develop high-quality reporting solutions

  • Produce comprehensive insights that really create value

  • Using Custom visualizations and themes

The course material includes:

  • 45 video lectures of more than 4 hours

  • 10 PBIX (Power BI) files

  • 7 PDF lectures

  • 1 PDF file of all DAX functions

  • 2 specialized txt codes

  • 1 Dataset in excel

  • 1 JSON files

Who this course is for:

  • Business, finance and sales professionals who want to extract insights from sales data

  • Students who want to pressure career as data analytics, business or financial analyst

  • Excel users who want to learn how to create professional reports in Power BI related to sales.

Who this course is for:

  • Sales professionals who want to extract insights from sales data for better decision making
  • Students who want to pressure career as data analytics, business or financial analyst
  • Data analytics, business or financial analyst who wants to learns sales analytics
  • Excel users who want to learn how to create professional reports in Power BI related to sales.

Course content

7 sections • 44 lectures • 4h 3m total length

  • Preview02:37

  • Preview00:51
  • Preview01:55
  • Preview01:33
  • Preview03:18
  • Develop Key Calculation Table and Calculate Total Sales
    05:21
  • Develop Dates Table
    03:26
  • Calculate Total Cost and Total Profits
    03:05
  • Calculate Total Unit Sold, Total Products and Profit Margin Percentage
    05:44
  • Dashboard - Page Background with Title and key cards
    04:39
  • Dashboard - Slicer of Years and Quarter
    03:18
  • Dashboard - Total Sales by Location, Dates and Salesperson
    06:23
  • Dashboard - Product-wise Sales with Map and Review of Sales Performance
    08:50

  • Preview00:37
  • Preview01:07
  • Product Insight - Calculate Top 5 Products
    05:34
  • Product Insight - Calculate Year on Year (YoY) Sales Growth
    07:17
  • Product Insight - Calculate Product Group Table and place it accordingly
    05:58
  • Product Insight - Create Scatter Chart with Product Growth Groups
    04:42
  • Product Insight Dashboard - Product Table Visualization
    05:52
  • Product Insight Dashboard - Scatter Chart and Top Products
    04:22
  • Product Insight Dashboard - Final Visualization and Product Review
    06:24
  • Customer Insight - Calculate Top 5 Customers
    03:32
  • Customer Insight - Time Intelligence Calculations
    05:35
  • Customer Insight - Customer Ranking in the Scatter Chart
    08:25
  • Customer Insight Dashboard - Final Visualization and Customer Review
    04:59
  • Sales Summary Dashboard - Final Visualization and Sales Review
    09:51
  • Sales Budget - Overview and Utilization of Time Intelligence Technique
    03:57
  • Sales Budget - Budget Formula and Final Visualization
    09:53

  • Preview00:59
  • Scenario 1 - Find out the Basket of Products
    04:29
  • Scenario 2 - Find customers purchasing products more than one time
    07:59
  • Scenario 3 - Find New Customers
    14:35
  • Scenario 4 - Find cross selling opportunities 1 of 2
    04:02
  • Scenario 4 - Find cross selling opportunities 2 of 2
    12:56
  • Scenario 5 - Find the Customer Group with more YoY Sales Growth
    11:00
  • Scenario 6 - Find the Product sales trends overtime
    04:51
  • Scenario 7 - Find Salespersons which are growing their Profits Margin
    06:35
  • AI Visual - Decomposition Tree
    06:58
  • AI Visual - Key Influencer
    04:36

  • Introduction about Power BI and How it is Installed
    04:25
  • Bird-eye view of Data Analysis Expression (DAX)
    05:44

  • Final Project
    08:10

  • Advance Visualization Technique
    06:37

Instructor

Muhammad Kashif
Financial & Business Analyst and Corporate Trainer
Muhammad Kashif
  • 4.2 Instructor Rating
  • 230 Reviews
  • 18,973 Students
  • 1 Course

I always found myself in the field of analysis through my career, as Management Accountant, which spans over sixteen years. I always took the challenge to discover insights from data for better decision making. I have been part of many exciting projects which range from feasibility studies, management consultancy, business analytics, corporate training and much more.

Through specific projects and training programs along with my work in Kaizen Analytic LLP, I help people and their organizations understand the application of business analytics techniques in their various parts of the organization to better understand the data and utilize it to increase their impact and make a position contributes to the world.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.