تصور البيانات باستخدام Power BI: انشئ لوحة معلومات للتسويق from Coursera

ذلك المشروع العملي يبدأ بتحميل البيانات على برنامج Power BI واستكشاف بيانات عملاء الشركة التاريخية والتأكد من جودتها باستخدام ال Power Query Editor ومن ثم، حساب قياسات قيمة عمر العميل مثل معدل المغادرة (Churn rate) ومتوسط مدة بقاء العميل ومتوسط قيمة الطلب (Average Order Value) والقيمة العمرية لكل عميل (CLV) باستخدام دوال ال DAX لتحليل بيانات العملاء وتقسيمهم لشرائح بناء على قيمتهم العمرية وعرض النتائج في هيئة رسومات بيانية مناسبة تُبيّن أعلى العملاء قيمة لدى الشركة لتحسين تجربتهم وزيادة رضائهم عن الشركة.

يتطلب هذا المشروع وجود حساب لك على Power BI تابع لمنظمة أو شركة ومعرفة كيفية التعامل مع واجهة Power BI desktop واستخدام ال Power Query Editor لعمل المهمات البسيطة الخاصة بتنظيف البيانات وإنشاء العواميد وكيفية عرض البيانات في جدول أو رسمة بيانية بسيطة واستعمال دوال ال DAX لإنشاء المتغيرات والقياسات الإحصائية البسيطة مثل العدد والمتوسط والحالات الشرطية.

What's inside

Syllabus

ملخص المشروع

يهدف ذلك المشروع الإرشادي إلى أن يجعلك قادرا على إنشاء لوحة معلومات خاصة بشركة اتصالات باستخدام Power BI لكي تساعدهم على معرفة قيمة عمر العملاء وأي العملاء الأكثر دخلًا للشركة للاهتمام بهم من قبل فريق التسويق وتقديم لهم عروض وخدمات خاصة لضمان بقائهم مع الشركة وزيادة نسبة ولائهم لها. ذلك المشروع العملي يبدأ بتحميل البيانات على برنامج Power BI واستكشاف بيانات عملاء الشركة التاريخية والتأكد من جودتها باستخدام ال Power Query Editor ومن ثم، حساب قياسات قيمة عمر العميل مثل معدل المغادرة (Churn rate) ومتوسط مدة بقاء العميل ومتوسط قيمة الطلب (Average Order Value) والقيمة العمرية لكل عميل (CLV) باستخدام دوال ال DAX لتحليل بيانات العملاء وتقسيمهم لشرائح بناء على قيمتهم العمرية وعرض النتائج في هيئة رسومات بيانية مناسبة تُبيّن أعلى العملاء قيمة لدى الشركة لتحسين تجربتهم وزيادة رضائهم عن الشركة. يتطلب هذا المشروع وجود حساب لك على Power BI تابع لمنظمة أو شركة ومعرفة كيفية التعامل مع واجهة Power BI desktop واستخدام ال Power Query Editor لعمل المهمات البسيطة الخاصة بتنظيف البيانات وإنشاء العواميد وكيفية عرض البيانات في جدول أو رسمة بيانية بسيطة واستعمال دوال ال DAX لإنشاء المتغيرات والقياسات الإحصائية البسيطة مثل العدد والمتوسط والحالات الشرطية.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

It provides quantitative and analytical approach to calculating Customer Lifetime Value (CLV), a crucial metric in marketing campaigns and customer retention strategies

Suitable for beginners and intermediate learners with foundational knowledge of Power BI. It provides stepping stones for developing practical skills in Customer Lifetime Value (CLV) analysis, segmentation, and visualization

Involves the use of DAX functions and Power Query Editor, which are crucial tools for data analysis and transformation in Power BI

Oriented towards professionals working in the telecommunications industry or those seeking to enhance their skills in customer analytics and data-driven decision-making within this sector

Requires access to Power BI software, which may incur additional costs for learners

Activities

Coming soon We're preparing activities for تصور البيانات باستخدام Power BI: انشئ لوحة معلومات للتسويق. These are activities you can do either before, during, or after a course.

Career center

Learners who complete تصور البيانات باستخدام Power BI: انشئ لوحة معلومات للتسويق will develop knowledge and skills that may be useful to these careers:

Marketing Analyst

Marketing Analysts use their analytical skills to help businesses understand their customers and make better marketing decisions. This course can help build a foundation for a career as a Marketing Analyst by teaching you how to use Power BI to analyze marketing data. You will also learn how to use DAX to create calculated columns and measures, which are essential skills for Marketing Analysts.

See salaries and explore the career path for Marketing Analyst

Customer Success Manager

Customer Success Managers use their analytical skills to help businesses retain customers. This course can help build a foundation for a career as a Customer Success Manager by teaching you how to use Power BI to analyze customer data. You will also learn how to use DAX to create calculated columns and measures, which are essential skills for Customer Success Managers.

See salaries and explore the career path for Customer Success Manager

Consultant

Consultants use their analytical skills to help businesses solve problems. This course can help build a foundation for a career as a Consultant by teaching you how to use Power BI to analyze data. You will also learn how to communicate your findings to stakeholders, which is an essential skill for Consultants.

See salaries and explore the career path for Consultant

Data Analyst

Data Analysts use their programming and analytical skills to transform raw data into meaningful insights. This course can help build a foundation for a career as a Data Analyst by teaching you how to use Power BI to clean, analyze, and visualize data. You will also learn how to use DAX to create calculated columns and measures, which are essential skills for Data Analysts.

See salaries and explore the career path for Data Analyst

Data Scientist

Data Scientists use their analytical skills to help businesses make data-driven decisions. This course can help build a foundation for a career as a Data Scientist by teaching you how to use Power BI to analyze data. You will also learn how to use DAX to create calculated columns and measures, which are essential skills for Data Scientists.

See salaries and explore the career path for Data Scientist

Business Analyst

Business Analysts use their analytical skills to help businesses improve their operations. This course can help build a foundation for a career as a Business Analyst by teaching you how to use Power BI to analyze data and identify trends. You will also learn how to communicate your findings to stakeholders, which is an essential skill for Business Analysts.

See salaries and explore the career path for Business Analyst

Financial Analyst

Financial Analysts use their analytical skills to help businesses make sound financial decisions. This course can help build a foundation for a career as a Financial Analyst by teaching you how to use Power BI to analyze financial data. You will also learn how to use DAX to create calculated columns and measures, which are essential skills for Financial Analysts.

See salaries and explore the career path for Financial Analyst

Product Manager

Product Managers use their analytical skills to help businesses develop and launch new products. This course can help build a foundation for a career as a Product Manager by teaching you how to use Power BI to analyze product data. You will also learn how to use DAX to create calculated columns and measures, which are essential skills for Product Managers.

See salaries and explore the career path for Product Manager

Sales Manager

Sales Managers use their analytical skills to help businesses increase sales. This course can help build a foundation for a career as a Sales Manager by teaching you how to use Power BI to analyze sales data. You will also learn how to use DAX to create calculated columns and measures, which are essential skills for Sales Managers.

See salaries and explore the career path for Sales Manager

Software Engineer

Software Engineers use their analytical skills to design, develop, and maintain software applications. This course may be useful for Software Engineers who want to learn how to use Power BI to analyze data and create visualizations.

See salaries and explore the career path for Software Engineer

Web Developer

Web Developers use their analytical skills to design and develop websites. This course may be useful for Web Developers who want to learn how to use Power BI to analyze website data and create visualizations.

See salaries and explore the career path for Web Developer

Data Engineer

Data Engineers use their analytical skills to design and build data pipelines. This course may be useful for Data Engineers who want to learn how to use Power BI to analyze data and create visualizations.

See salaries and explore the career path for Data Engineer

Database Administrator

Database Administrators use their analytical skills to manage and maintain databases. This course may be useful for Database Administrators who want to learn how to use Power BI to analyze database data and create visualizations.

See salaries and explore the career path for Database Administrator

IT Manager

IT Managers use their analytical skills to manage IT departments. This course may be useful for IT Managers who want to learn how to use Power BI to analyze IT data and create visualizations.

See salaries and explore the career path for IT Manager

Project Manager

Project Managers use their analytical skills to manage projects. This course may be useful for Project Managers who want to learn how to use Power BI to analyze project data and create visualizations.

See salaries and explore the career path for Project Manager