PDG Consulting has built a reputation in helping companies take advantage of their most important asset: their own data. We use cutting-edge, scalable, and cloud-native big data technologies in our software architecture services to drive data-led transformations, enabling organizations to make data-driven decisions as close to real-time as possible. Collection, management, and near real-time availability of structured and unstructured data is just the start of the value realization process. The right story must be told with your data to the right people so that decisions can be made to maximize business value and realize growth opportunities. An effective business intelligence solution will deliver the data needed to drive your business forward, no matter if your executives need to view corporate KPI reports from the office, or your sales team needs to run inventory tracking reports in the field.
Technologies
We approach each new client project by assessing existing systems and desired outcomes. From there, we develop new data analytics and business intelligence tools to create tailored solutions. Whether your organization needs to build a data warehouse from scratch or improve upon the metrics your current business intelligence reports provide, PDG can help set an optimal data strategy that will support your company’s growth.
Below are just a few examples of the technologies we have used as part of our software architecture services to improve our clients’ data architectures:
Big Data Technologies
- Apache Spark
- Apache Hadoop
- Apache Kafka
- Hive
- Presto
- Amazon Elastic Map Reduce (EMR)
- Amazon Glue
- Amazon Kinesis
- Amazon Firehose
- Amazon Athena
- NoSQL databases
- Microsoft SQL Server Integration Services (SSIS)
- Microsoft SQL Server Analysis Services (SSAS)
- Elasticsearch
Big Data Technologies
- Apache Spark
- Apache Hadoop
- Apache Kafka
- Hive
- Presto
- Amazon Elastic Map Reduce (EMR)
- Amazon Glue
- Amazon Kinesis
- Amazon Firehose
- Amazon Athena
- NoSQL databases
- Microsoft SQL Server Integration Services (SSIS)
- Microsoft SQL Server Analysis Services (SSAS)
- Elasticsearch
Business Intelligence & Data Visualization Technologies
- Tableau
- Qlik (Qlik Sense)
- Amazon QuickSight
- Splunk
- Microsoft Power BI
- Grafana
- Kibana
Business Intelligence & Data Visualization Technologies
- Tableau
- Qlik (Qlik Sense)
- Amazon QuickSight
- Splunk
- Microsoft Power BI
- Grafana
- Kibana
Why Choose PDG Consulting as your Big Data / Business Intelligence solutions provider?
At PDG we develop big data solutions that empower business leaders with usable strategic knowledge unique to their goals and data reporting requirements. Flexibility and customization are essential components of every effective big data and BI project. Contact us today to learn more about how we use different software architecture technologies to accomplish these goals.
Getting the Most Out of Your Business Intelligence Dashboard
Business intelligence (BI) solutions serve a dual purpose. However, getting the most out of BI…
A State-of-the-Art Business Intelligence Platform For Ad Performance Analysis and Optimization—With Predictive Capabilities (White Paper)
At PDG Consulting, we work with a wide variety of clients in all types of industries—including…
Data Integration for Cloud Data Lakes: Architecture and Best Practices (White Paper)
Having the ability to make accurate data-driven business decisions in near real-time is a practical…
Related Projects
Project Name
Data Consolidation and Visualization
Overview
PDG was tasked with digitalizing and consolidating data from dozens of source systems across the company into a centralized Enterprise Data Warehouse, including the creation of a robust data visualization and analytics front-end through Qlik Sense. PDG provides service at every level — from requirements gathering, data consolidation gap-fit analysis, and custom web solutions for business user data maintenance — to data modeling and ETL, Visualization development in Qlik Sense, and user onboarding and adoption training.
Tech Stacks
MS SQL Server | Angular | Qlik Sense | SSIS | S3
Project Name
Tax Process Optimization
Overview
PDG owned and project managed the development of the EPIC TPO project, a domestic and international tax processing application that consumes data from SAP-BW, applies a set of tax business rules, and produces book to tax adjustments based on differences in GAAP and tax law. The system also lets business users to make additional topside or other adjustments to produce Warner Bros final pre-tax income.
Tech Stacks
SAP | Web UI | Enterprise Data Warehouse | .net
Project Name
Enterprise Production Incentive Cockpit
Overview
PDG owned and project managed the development of the EPIC enterprise portal used to track Theatrical and Television production tax credits, both domestically and internationally. By integrating the business processes of Production Planning, Theatrical & Television Finance, Treasury, and Tax, EPIC has streamlined and optimized the way WB, HBO, and Turner manage production credits, creating increased visibility and control of the credit process.
Tech Stacks
SAP | Web UI | Enterprise Data Warehouse | .net
Project Name
Sales Analytics and Data Insights
Overview
PDG helped Sony's Distribution Sales Analytics and Data Insights team democratize advanced analytics by creating alternative reporting tools to support sales, sales planning, sales strategy, and marketing areas. PDG designed and developed the analytical reporting database, created the BI data pipelines from source to end user, and supported the development of various business data models and KPI's that are socialized through various reporting tools and dashboards. By developing key metrics and normalizing data across territories and markets, the data is more easily accessible — empowering each group supported with shared insights and analyses.
Tech Stacks
Teradata | Alteryx | Tableau
Project Name
Domestic and International TV Distribution
Overview
PDG redesigned CBS’s existing PDS rights management system and implemented a custom title availability reporting system utilizing a custom version of PDG’s CCAE software suite. Licensing modules were redesigned to support new contract paradigms and rights including complex license carveouts, and non-linear catch-up rights in numerous forms.
Tech Stacks
C# | Microsoft .NET 4.5 | Angular 6 | Microsoft SQL Server
Project Name
Revenue Pipeline Management (RPM)
Overview
PDG supported the analysis and requirements gathering processes along with owned the technical design, development, and worldwide rollout of this custom system. RPM integrates existing sales & distribution systems with a custom data warehouse and forecasting application in order to increase television sales by providing more information about product availability. The distribution system handles all licensing, customer, fee, and shipping information for 300,000+ titles and thousands of concurrent deals. RPM is used by hundreds of sales planners and finance users worldwide.
Tech Stacks
Java EE | Spring | Angular 7 | DevExtreme | Active MQ | Oracle DB | Microsoft SQL Server | Microsoft SSAS
Project Name
Film & Television Distribution
Overview
To provide near real-time contract validation and availability reporting, PDG installed its cloud-based CCAE application suite to augment Fox’s contract management system and manage its multi-billion-dollar distribution business. Additionally, enterprise messaging services were built out to connect product, rights, release, and scheduling metadata throughout the organization.
Tech Stacks
PDG CCAE v3.0 – Java | Spring | Angular 6 | Kafka | PostgreSQL | AWS EC2 | Splunk
Project Name
TV Production Data Warehouse
Overview
For this project, PDGC managed the data warehouse and report development while also providing functional and technical design. This included managing and making key design decisions for the development of the ETL process, data model, reports, and automated Excel applications. PDGC also designed and managed the development of web and mobile-based Microstrategy production budget executive dashboards. The data warehouse provides consolidated cost and budget data from SAP and three external production accounting systems (Entertainment Partners, Cast and Crew, and Ease Accounting). This allows for the automation of numerous finance processes including the production recap (budget and forecast) consolidation and reporting process for over 100 users across all TV productions providing visibility to up-to-date forecasts through reports and executive dashboards.
Tech Stacks
SAP | Teradata | Informatica | Microstrategy | Cast & Crew | Ease Accounting | Excel
Project Name
SAP BPC support
Overview
PDG provided application support for the implementation of SAP S4 Hana and BPC to fulfill STX’s financial accounting, forecasting, and consolidations needs. STX uses BPC to perform film, television, digital, and home entertainment P&L forecasting on both a cash and accrual basis.
Tech Stacks
SAP BPC 10.1 | SAP AO | S4 Hana
Project Name
SAP Digital Transformation
Overview
PDG provided SAP solution architecture, project management, and business intelligence experts for a full top to bottom digital and technology transformation project to implement best-of-breed 21st-century technologies in order to bring them into the digital age. Using a full SAP stack starting with their e-commerce website & mobile apps through to outbound logistics and everything in between. Jafra is changing the way its customers do business.
Tech Stacks
SAP Hybris | Vistex | SAP ECC | SAP EWM | SAP TM | SAP CRM | SAP PI | MS SQL Server / BI | Java | Spring Framework | IOS | Android
Project Name
SteelPro ERP
Overview
PDG helped to program manage and provide advisory services for the implementation of Cemco's industry-specific ERP, assisting with stabilizing the system from both a performance and utility perspective. PDG also organized the implementation and roll-out of the system to the various manufacturing plants nationwide.
Tech Stacks
SteelPro | Microsoft .NET | Microsoft SQL Server | Microsoft BI Stack | Angular | AWS
Project Name
Microsoft Business Intelligence
Overview
The PDG team successfully built and demoed a POC within 2 months resulting in the implementation of a BI solution that improves the performance and functionality of CEMCO's reporting capabilities involving over 70 reports.
Tech Stacks
Microsoft SQL Server | SSIS | SSAS | Power BI
Project Name
DIRECTV Advanced Business Planning
Overview
PDG built a Business Intelligence tool that provides high-value dashboards to ATT Advertising business stakeholders as well as Tech Ops. It allows users to drill down and slice and dice across huge volumes of historical ad performance and customer behavior events. In addition to creating an actionable, centralized data lake for all things ad-related, its main value resides in providing predictive algorithms that leverage big data and Spark distributed computing, which allows users to visualize the predicted performance of upcoming advertising campaigns.
Tech Stacks
Spark | Scala | Spring | AWS Glue | Amazon QuickSight | Amazon EMR | Amazon S3 | Redis | AWS CloudFormation
Project Name
SAP ERP Business Planning
Overview
PDGC helped implement the automation and standardization of the FP&A processes for the Television Distribution group at NBCUniversal with the goal being to transition all their planning models in Excel into a comprehensive BPC Solution to speed up processes.
Tech Stacks
SAP BPC | SAP HANA | ABAP