# Data Destinations

> **Note:** Once you've [connected sources](https://knowledge.powermyanalytics.com/application/sources/sources-guide/) and [built datasets](https://knowledge.powermyanalytics.com/application/tools/data-builder-guide/), Power My Analytics offers multiple ways to visualize, analyze, and export your data. Not sure which to choose? Most users start with Data Visualization or Spreadsheets for immediate insights.

## ![Reports](https://knowledge.powermyanalytics.com/application/images/data-destinations-1.svg) Reports & Analysis

*For users who want to visualize and analyze their data*

### Data Visualization (Most Popular)

Create interactive dashboards and visual reports that tell compelling stories with your marketing data.

#### ![Data Studio](https://knowledge.powermyanalytics.com/application/images/data-destinations-2.svg) **Data Studio**

- **Best for**: Client reporting, performance dashboards, shareable reports
- **Features**: Free, web-based, real-time collaboration
- **Time to setup**: 5-10 minutes with templates
- [View Data Studio guide →](https://support.powermyanalytics.com/portal/en/kb/knowledge-base/reports/reports-data-visualization/looker-studio)
- [Watch video tutorial →](https://knowledge.powermyanalytics.com/application/tools/data-builder-guide/#how-to-send-a-dataset-to-data-studio)

#### ![Power BI](https://knowledge.powermyanalytics.com/application/images/data-destinations-3.svg) **Power BI**

- **Best for**: Enterprise reporting, complex data models, Microsoft ecosystem
- **Features**: Advanced analytics, AI insights, mobile apps
- **Time to setup**: 10-15 minutes
- [View Power BI guide →](https://support.powermyanalytics.com/portal/en/kb/knowledge-base/reports/reports-data-visualization/power-bi)

#### ![Tableau](https://knowledge.powermyanalytics.com/application/images/data-destinations-4.svg) **Tableau**

- **Best for**: Advanced data visualization, statistical analysis
- **Features**: Powerful calculations, advanced chart types
- **Time to setup**: 15-20 minutes
- [View Tableau guide →](https://support.powermyanalytics.com/portal/en/kb/knowledge-base/reports/reports-data-visualization/tableau)

### Spreadsheets

Auto-updating spreadsheets that refresh with your latest marketing data. Perfect for detailed analysis and custom calculations.

#### ![Google Sheets](https://knowledge.powermyanalytics.com/application/images/data-destinations-5.svg) **Google Sheets**

- **Best for**: Budget tracking, campaign analysis, data manipulation
- **Features**: Real-time collaboration, custom formulas, pivot tables
- **Time to setup**: 2-5 minutes
- [View Google Sheets guide →](https://knowledge.powermyanalytics.com/application/reports/google-sheets-data-integration-guide/)

#### ![Microsoft Excel](https://knowledge.powermyanalytics.com/application/images/data-destinations-6.svg) **Microsoft Excel**

- **Best for**: Complex analysis, VBA automation, offline access
- **Features**: Advanced formulas, macros, Power Query integration
- **Time to setup**: 2-5 minutes
- [View Excel guide →](https://knowledge.powermyanalytics.com/application/reports/microsoft-excel-data-integration-guide/)

---

## 🔄 Data Exports & Pipelines

*For users who need data in external systems*

![API](https://knowledge.powermyanalytics.com/application/images/data-destinations-7.svg)

 **API Access**

Programmatically access your data for custom applications and integrations.

- **Best for**: Custom dashboards, app integrations, automated workflows
- **Features**: RESTful endpoints, JSON format, authentication
- [View API documentation →](https://knowledge.powermyanalytics.com/application/tools/get-started-with-power-my-analytics-api/)

### ![BigQuery](https://knowledge.powermyanalytics.com/application/images/data-destinations-8.svg) **BigQuery**

Stream your marketing data directly to Google's enterprise data warehouse.

- **Best for**: Large-scale analytics, machine learning, joining with other data
- **Features**: Serverless, real-time analysis, Google Cloud integration
- **Update frequency**: Hourly or daily
- [View BigQuery guide →](https://knowledge.powermyanalytics.com/application/exports/how-to-export-to-bigquery/)

### ![FTP](https://knowledge.powermyanalytics.com/application/images/data-destinations-9.svg)

 **FTP/SFTP**

Scheduled file delivery to FTP servers for legacy system integration.

- **Best for**: Legacy systems, partner data sharing, automated file transfers
- **Features**: Scheduled delivery, multiple file formats, secure transfer
- **Formats**: CSV, TSV, JSON
- [View FTP guide →](https://knowledge.powermyanalytics.com/application/exports/how-to-export-to-ftp/)

### ![Google Analytics 4](https://knowledge.powermyanalytics.com/application/images/data-destinations-10.svg)

 **Google Analytics 4**

Send your marketing data into GA4 for unified analytics.

- **Best for**: Multi-channel attribution, audience building, remarketing
- **Features**: Event tracking, custom dimensions, audience integration
- [View GA4 export guide →](https://support.powermyanalytics.com/portal/en/kb/articles/ga4-cost-import-field-mappings)

### ![SQL](https://knowledge.powermyanalytics.com/application/images/data-destinations-11.svg)

 **SQL Databases**

Direct integration with your SQL databases for enterprise data management.

#### Supported Databases:

- ![Azure SQL](https://knowledge.powermyanalytics.com/application/images/data-destinations-12.svg)

     **Azure SQL Warehouse** - [Setup guide →](https://knowledge.powermyanalytics.com/application/exports/how-to-export-to-azure-sql/)

- ![MySQL](https://knowledge.powermyanalytics.com/application/images/data-destinations-13.svg)

     **MySQL** - [Setup guide →](https://knowledge.powermyanalytics.com/application/exports/how-to-export-to-mysql/)

- ![PostgreSQL](https://knowledge.powermyanalytics.com/application/images/data-destinations-14.svg)

     **PostgreSQL** - [Setup guide →](https://knowledge.powermyanalytics.com/application/exports/how-to-export-to-postgresql/)

- **Best for**: Custom BI tools, data warehousing, enterprise reporting
- **Features**: Automatic schema creation, incremental updates, data type mapping

---

## 🎯 Quick Start Recommendations

### "I want to..."

- **Show clients their campaign performance** → Start with **Data Studio**
- **Track budgets and spending in detail** → Use **Google Sheets**
- **Get quick insights without building reports** → Try **AI Insights** 🆕
- **Feed data into our company's data warehouse** → Set up **BigQuery** or **SQL**
- **Share data files with partners** → Configure **FTP** delivery
- **Build enterprise dashboards** → Choose **Power BI** or **Tableau**
- **Access data programmatically** → Use our **API**

---

Remember: You can always start with one destination type and add others later as your needs grow!
